SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 54088: The baseline_sas_validate_schema.sas job generates the error "BY variables are not properly sorted on data set WORK.COMP_CONSTRAINTS"

DetailsHotfixAboutRate It

The SAS® Merchandise Intelligence baseline_sas_validate_schema.sas job might generate the following error in the baseline_sas_validate_schema.sas log file. This job is run only during migration from a prior release of SAS® Revenue Optimization or SAS® Size Optimization to release 5.2.

ERROR: BY variables are not properly sorted on data set WORK.COMP_CONSTRAINTS.
memname=VENDOR column_name=VENDOR_SK constraint_name=PRIM_KEY constraint_type=PRIMARY FIRST.memname=1 LAST.memname=1 COLUMN_NAMES=VEHICLE_SUPPORT_MAP_SK _ERROR_=1
_N_=218
NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 219 observations read from the data set WORK.COMP_CONSTRAINTS.
      WHERE constraint_type='PRIMARY';
WARNING: The data set WORK.COMP_PK_COLUMNS may be incomplete.  When this step was stopped there were 104 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds

ERROR: BY variables are not properly sorted on data set WORK.COMP_CONSTRAINTS.
memname=VEHICLE_SUPPORT_MAP_PREV column_name=SUPPORT_NM constraint_name=_NM0002_ constraint_type=NOT NULL FIRST.memname=1 LAST.memname=0 _ERROR_=1 _N_=23
NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 24 observations read from the data set WORK.COMP_CONSTRAINTS.
      WHERE constraint_type='NOT NULL';
WARNING: The data set WORK.COMP_NOT_NULL_CONS may be incomplete.  When this step was stopped there were 22 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds

This error occurs when data in the DICTIONARY.CONSTRAINT_COLUMN_USAGE table or the DICTIONARY.TABLE_CONSTRAINTS table is not in the expected sort order.

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Promotion OptimizationLinux for x645.2_M45.49.3 TS1M29.4 TS1M3
Microsoft® Windows® for x645.2_M45.49.3 TS1M29.4 TS1M3
SAS SystemSAS Retail ForecastingLinux for x645.2_M45.49.3 TS1M29.4 TS1M3
Microsoft® Windows® for x645.2_M45.49.3 TS1M29.4 TS1M3
SAS SystemSAS Markdown OptimizationMicrosoft® Windows® for x645.2_M45.49.3 TS1M29.4 TS1M2
Linux for x645.2_M45.49.3 TS1M29.4 TS1M2
SAS SystemSAS Regular Price OptimizationLinux for x645.2_M45.49.3 TS1M29.4 TS1M3
Microsoft® Windows® for x645.2_M45.49.3 TS1M29.4 TS1M3
SAS SystemSAS Pack OptimizationMicrosoft® Windows® for x643.2_M43.49.3 TS1M29.4 TS1M2
64-bit Enabled AIX3.2_M43.49.3 TS1M29.4 TS1M2
Linux for x643.2_M43.49.3 TS1M29.4 TS1M2
SAS SystemSAS Size ProfilingMicrosoft® Windows® for x643.2_M43.49.3 TS1M29.4 TS1M2
64-bit Enabled AIX3.2_M43.49.3 TS1M29.4 TS1M2
Linux for x643.2_M43.49.3 TS1M29.4 TS1M2
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.